LEGION Model Builder Help

Entities worksheet

This worksheet enables you to create Entity Types and organise your Supply Types.

Parent topic: The Data Template Spreadsheet

Creating Entity Types with the Data Template spreadsheet

Use the top section of the ‘Entities’ worksheet, labelled ‘Entity Types’. To create an Entity Type you need to define name; colour; Entity category; Gender ratios; and Size and Speed Profiles in the same column.

To create an Entity Type:

  1. In the cell to the right of the cell labelled ‘Name’, enter a name.
  2. In the cell beneath (next to ‘Colour’), either leave the colour as it is or click the 'Fill' icon on the toolbar and pick a colour from the palette (different versions of Excel may have different methods for changing the colour of cells).
  3. In the cell beneath (next to ‘Category’), select a category from the drop-down list.
  4. In the cell beneath (next to 'Gender'), enter a percentage for males (any remaining percentage will be female).
  5. In the cell beneath (next to ‘Entity size’) select Default to use system settings or Custom to use an Entity Size Profile.
    • If you choose Custom, select profiles from the drop-down lists labelled 'Male' and 'Female'.
  6. In the cell beneath (next to ‘Speed Profile-Flat Ground’), select a profile from the drop-down list (look out for profiles you may have created on the ‘Entity profiles’ worksheet).
  7. In the cell beneath (next to ‘Luggage’), select a luggage size from the drop-down list (this includes: None, Small, Medium, Large, Random plus any Luggage size Profiles you created on the Entity Profiles worksheet).
  8. In the cell beneath (next to ‘Flat Ground’), select one of the available profiles from the drop-down list (this includes built in profiles related to the 'Category' of Entity you chose in step 3 plus any Entity Speed profiles you created on the 'Entity profiles' worksheet).
  9. For the cells labelled 'Up and 'Down' you can choose one of the following options from their drop-down lists:
    • Inferred (software will calculate the speed of Entities going up or down stairs.)
    • Any other profiles you created on the 'Entity profiles' worksheet
  10. Repeat steps 1 to 6 for any further Entity Types you want to create, filling in new cells and columns as you progress across the worksheet.

Creating Supply Types with the Data Template spreadsheet

Use the bottom section of the ‘Entities’ worksheet, labelled ‘Supply Types’. To create a Supply Type, you need to define its name and add percentage values for the different Entity Types you want it to contain.

To create a Supply Type:

  1. In an empty cell in the column labelled ‘Supply Type name’, type in a name.

    The cells to the right of this name belong to columns headed by the names of Entity Types and are used for specifying the percentage of Entity Types that comprise the Supply Type.

  2. Find an Entity Type that you want to add to your Supply Type, and, where its column intersects with the Supply Type row, add a percentage for the Entity Type (for example, enter 50% where ‘Supply Type 1’ and ‘Tourists’ intersect if you need half of your Supply Type to consist of ‘Tourists’.
    Note: Each Supply Type must eventually have a ‘Composition’ of 100% to avoid an error.
  3. Repeat step 2 for any further Entity Types you would like to add to your Supply Type.